import sqlalchemy as sa

from like.models.base import Base


class Test(Base):
    """测试实体"""
    __tablename__ = 'test'
    __table_args__ = {
        'mysql_engine': 'InnoDB',
        'mysql_charset': 'utf8mb4',
        'mysql_collate': 'utf8mb4_general_ci',
        'mysql_row_format': 'Dynamic',
        'comment': '测试表',
    }
    id = sa.Column(sa.Integer(), primary_key=True)  # 主键
    sex = sa.Column(sa.Integer())  # 性别
    name = sa.Column(sa.String())  # 名称
    sort = sa.Column(sa.Integer())  # 排序
    is_show = sa.Column(sa.Integer())  # 是否显示: 0=否, 1=是
    is_delete = sa.Column(sa.Integer())  # 是否删除: 0=否, 1=是
    create_time = sa.Column(sa.Integer())  # 创建时间
    update_time = sa.Column(sa.Integer())  # 更新时间
    delete_time = sa.Column(sa.Integer())  # 删除时间


test = Test.__table__
